Booknew Database for Reviews and Products
Booknew Data
id pid name \
0 1 B00OAMFOF0 Rechargeable Reading Lamp for Bed & Music Stan...
1 2 1628600543 It Starts With Food: Discover the Whole30 and ...
2 3 1476746583 All the Light We Cannot See
3 4 B0039W9S0E The Book Of Love
4 5 0996275460 Adult Coloring Books: A Coloring Book for Adul...
path price
0 http://www.amazon.com/Rechargeable-Reading-Mus... $16.95
1 http://www.amazon.com/Starts-Food-Discover-Who... $16.17
2 http://www.amazon.com/All-Light-We-Cannot-See/... $16.20
3 http://www.amazon.com/The-Book-Of-Love/dp/B003... $9.99
4 http://www.amazon.com/Adult-Coloring-Books-Fea... $12.89
Booknew Reviews
id rid rname pid \
0 1 R2LHYLHQSHW2UK Jackie Cooper 0996275460
1 2 R2HKTQ2M22BXNT thebrassbutterfly B00OAMFOF0
2 3 R3AJJCUXRFWEBZ SK preacher 1628600543
3 4 R18SRHT1IPWDXH Tonya Weber 0996275460
4 5 R20KSJJKOZU1VA Jenna Frye 1476746583
review
0 Filled with Captivating, Complex and Intricate...
1 My wife has been complaining about every small...
2 I am a runner so my eating has been centered a...
3 Love it! Printed only on one side.
4 It has been a while since I have found a book ...
Joining Product with Reviews..
Comp Database for Reviews and Products
Comp Data
id pid name \
0 1 B007RP7JU0 Dell OptiPlex 760 Desktop Intel Core 2 Duo 2.0...
1 2 B00JS96S0U 2016 Newest Dell Inspiron 15 15.6" Premium Hig...
2 3 B01C5GU4KM RCA Viking Pro 10.1" 2-in-1 Tablet 32GB Quad C...
3 4 B0174AX43I Apple A1181 Macbook 13.3 Laptop Intel C2D 2.4G...
4 5 B00159LRXY RCA Viking Pro 10" 2-in-1 Tablet 32GB Quad Cor...
path price
0 http://www.amazon.com/Dell-OptiPlex-Profession... $319.98
1 http://www.amazon.com/Dell-15-Performance-Dual... $119.99
2 http://www.amazon.com/Viking-Pro-Computer-Touc... $124.79
3 http://www.amazon.com/Apple-Macbook-Laptop-OSX... $449.99
4 http://www.amazon.com/Viking-Pro-Computer-Touc... $149.88
Comp Reviews
id rid rname pid \
0 1 R3D7ES77RU9TET Pat The Cat B00JS96S0U
1 2 R11B6NMM2Y8OZC John Vleck B00UTV8OEE
2 3 R101TS9NXF6QT1 Karen B00JS96S0U
3 4 R3H11HIP4SCL9V GratefulEd B00UTV8OEE
4 5 RDA4UJY4S5Z0D Vovi Wetzel B001BBKNI6
review
0 This is the best "used or refurbished" PC that...
1 This is a good 2 in 1 tablet for just about an...
2 This was a great buy! Very economical & the co...
3 This is a good cross between a small laptop an...
4 I ordered this desk for my college student at ...
Joining Product with Reviews..
Desktop Database for Reviews and Products
Desktop Data
id pid name \
0 1 B0027A5J9S Fredrix Desktop Inkjet Canvas 8.5 in. x 11 in....
1 2 B019F9JH78 Dell Optiplex 755 H R Desktop
2 3 B018K0NOMC ABLEGRID® 5V 10A 50W 5-Port USB Charger Travel...
3 4 B015Z3PV4Q Opolar F60 Desktop USB Fan, Mini Table Fan for...
4 5 B00JS96S0U Dell OptiPlex 760 Desktop Intel Core 2 Duo 2.0...
path price
0 http://www.amazon.com/Fredrix-Desktop-Inkjet-C... $19.02
1 http://www.amazon.com/Dell-DELL-755-Optiplex-D... $20.98
2 http://www.amazon.com/ABLEGRID%C2%AE-Charger-D... $16.99
3 http://www.amazon.com/F60-Desktop-Powered-Pers... $119.00
4 http://www.amazon.com/Dell-OptiPlex-Profession... $19.79
Desktop Reviews
id rid rname pid \
0 1 RRO7VX5LEJX4C S. R. Bryan B00FJF4T76
1 2 R2896J1B8YFIK1 Protosapien B00FJF4T76
2 3 R3D4SJJ4PA4U9X count_zero B00FJF4T76
3 4 R1Q2Q7KU1T9DMA MLP B00FJF4T76
4 5 RMGB8VZMA5HP9 colloquialism B00FJF4T76
review
0 Granted I just bought this so time will tell i...
1 This is the second (and last) time I'm returni...
2 I love this box-- couple little things. Came w...
3 I just received a ThinkServer TS140 modified b...
4 I am a software engineer with some extra cash ...
Joining Product with Reviews..
id_x pid name \
0 1 B00OAMFOF0 Rechargeable Reading Lamp for Bed & Music Stan...
1 1 B00OAMFOF0 Rechargeable Reading Lamp for Bed & Music Stan...
2 1 B00OAMFOF0 Rechargeable Reading Lamp for Bed & Music Stan...
3 1 B00OAMFOF0 Rechargeable Reading Lamp for Bed & Music Stan...
4 1 B00OAMFOF0 Rechargeable Reading Lamp for Bed & Music Stan...
path price id_y \
0 http://www.amazon.com/Rechargeable-Reading-Mus... $16.95 2
1 http://www.amazon.com/Rechargeable-Reading-Mus... $16.95 6
2 http://www.amazon.com/Rechargeable-Reading-Mus... $16.95 14
3 http://www.amazon.com/Rechargeable-Reading-Mus... $16.95 25
4 http://www.amazon.com/Rechargeable-Reading-Mus... $16.95 38
rid rname \
0 R2HKTQ2M22BXNT thebrassbutterfly
1 R1CB7I6SVV0O92 OceanWave
2 R33MZJ4J6NDCD9 David
3 R31WANGJH4VPHD Don Porter
4 RZ9T0HH2KZXWU Mike Tarrani
review Type
0 My wife has been complaining about every small... book
1 I have read my way through many book lights; t... book
2 This is my video review- I've had reviews on ... book
3 Worked for 2 days (always plugged in) and then... book
4 I've gone through a number of music stand ligh... book
Droping id_x and id_y cols ...